UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZAy9ksu8VJUc8WWCk1AZKjeWKVXFdBDpgQNrXcOFRo='
WHERE
key_id = '1a892e1e6efb69a5b6728d4eef40ca3b571debcd4c665064cd0677bd5d2d38f4'
AND (
token = '7ZAy9ksu8VJUc8WWCk1AZKjeWKVXFdBDpgQNrXcOFRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)