UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NLY55Lkb8FBMxCtlsqP7ZdNCDxmB2OvUTI1IZ64jm4U='
WHERE
key_id = 'a93df9e2b3596c71f36eb36e3101dbcbd88e2df09113293220657bc8b1a09269'
AND (
token = 'NLY55Lkb8FBMxCtlsqP7ZdNCDxmB2OvUTI1IZ64jm4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)