UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2QUNB3iv45bEVP5QoR3m3ea5Y8/9A7lo1MA+7Om+uKo='
WHERE
key_id = 'a7b85e13400caeeb8f3ddd903aacc16e4d3f1e7fc4e4768f3b173b68dc7aeb6a'
AND (
token = '2QUNB3iv45bEVP5QoR3m3ea5Y8/9A7lo1MA+7Om+uKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)