UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KfytHhEwvghN8BsTPWeVDCvG8kQiESYqx5GGgkCGrEw='
WHERE
key_id = '2a3218ab33932b80cc44893142d78e05fdc4f274b758b5f31e5f4b07a165fff6'
AND (
token = 'KfytHhEwvghN8BsTPWeVDCvG8kQiESYqx5GGgkCGrEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)