UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zF4qld5wVjqybuWUqxjePXxjAZ8mOialRbRtqBcCcU='
WHERE
key_id = 'a719d1b92f5777cbe281626635c4dde70a18a480a4bef06070b471a29a538870'
AND (
token = '9zF4qld5wVjqybuWUqxjePXxjAZ8mOialRbRtqBcCcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)