UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vqVTnMl+CQ8V1LnWwsEueWu7pSa0u5jpNoQBvcn0oeA='
WHERE
key_id = 'c1712bc7b92592ac5e0e7c9a0f9eac7f427fd0bffa099f3acb96f190ae1ce827'
AND (
token = 'vqVTnMl+CQ8V1LnWwsEueWu7pSa0u5jpNoQBvcn0oeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)