UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zW+M4Kw7J0WdpfWQ50kahObKaMlBeTYUF/iwOU4hNiA='
WHERE
key_id = 'd6deb54092032d6b403ef8a7900b8e6c736490d3321afc714ce6caedc809adf7'
AND (
token = 'zW+M4Kw7J0WdpfWQ50kahObKaMlBeTYUF/iwOU4hNiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)