UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S/E0mHPb9ZNu/CwOo4xL2vNqDm302fvz3lsOSO+up4c='
WHERE
key_id = 'dad6f955208c204b5039e7b32438479ecbe8def7f9d54445e7d7fc9cea3ee50b'
AND (
token = 'S/E0mHPb9ZNu/CwOo4xL2vNqDm302fvz3lsOSO+up4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)