UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5HBpJyj3usNkeJcX/0NyOqHcE6U2jPlNZp3M/DY7Q5s='
WHERE
key_id = 'ec74ca0cce2f1467a3ab49f2bad4449b87862c5b5b740162ef9ad072ffd71a60'
AND (
token = '5HBpJyj3usNkeJcX/0NyOqHcE6U2jPlNZp3M/DY7Q5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)