UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E91sz2gITnFydmcrZxfvaODlkI5ltrLJytqb8iAy2Uo='
WHERE
key_id = '27ab0958fe95ef897aa0159825697b5d4cb9c624a8d5439a3f7b3af229263ed6'
AND (
token = 'E91sz2gITnFydmcrZxfvaODlkI5ltrLJytqb8iAy2Uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)