UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmU8jJOKET4ZhOTHeTz4HuWt8BxOSRoNoyJ4ig5CtxM='
WHERE
key_id = '593e73f4b2cf24791a9a4f5d24a4f03cd1d7c3b03381141d8f1fb60e30fa2790'
AND (
token = 'tmU8jJOKET4ZhOTHeTz4HuWt8BxOSRoNoyJ4ig5CtxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)