UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9QLw/n4uclkt6VyDgn5U/6aaMuJB7X/RVq+xf35+04='
WHERE
key_id = 'ecfaf4ad9f34e3776cb6c1f5e859a37c497d36239fe86b108d308fb70f9a4a72'
AND (
token = 'X9QLw/n4uclkt6VyDgn5U/6aaMuJB7X/RVq+xf35+04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)