UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thEkMy3DI3rc7Q3hAw/j77GFiotn4uUPc/BVSe7XzNw='
WHERE
key_id = '46714cf1fb5d33a66062c4fcdcf5d656a7145136b3156b2f3c921ade00ec30d3'
AND (
token = 'thEkMy3DI3rc7Q3hAw/j77GFiotn4uUPc/BVSe7XzNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)