UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pu3816hOTeMGE+k6QblAAVkweW+CKXGX/8uNzOV4uXc='
WHERE
key_id = 'ce63192346731dff833f0c412cba72ea641a04ab2b66e40c212e0de0a78f6ceb'
AND (
token = 'pu3816hOTeMGE+k6QblAAVkweW+CKXGX/8uNzOV4uXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)