UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g+uI9jU9dvguxiL5r4fcmsg+qdZSxfNAJhlZNK8a+5g='
WHERE
key_id = 'fc2bfc6f392e04c7435b6427b9d5e3416a6ffc72914f0cadd7ee37e48df5fded'
AND (
token = 'g+uI9jU9dvguxiL5r4fcmsg+qdZSxfNAJhlZNK8a+5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)