UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TtQ9XP7XNxpENbQUwkfOj7XywxflQ6yMIaJXkNRcXO0='
WHERE
key_id = 'bc129d69509e0d51e887b717696d8fd6ff61e6873d3fa303a9182478e93c2623'
AND (
token = 'TtQ9XP7XNxpENbQUwkfOj7XywxflQ6yMIaJXkNRcXO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)