UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6RlUb80zkCRAOi7KkxREyvI5Ik9OdOw1FEXD8he/x9M='
WHERE
key_id = 'c848c7f22e7db81309de6f952a911e60b645004c861f319efcc45047913adec4'
AND (
token = '6RlUb80zkCRAOi7KkxREyvI5Ik9OdOw1FEXD8he/x9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)