UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'naGT6ZcRSylC7hXDt/jnNQbOe7sOfQ6ZgaCtIpMT4rY='
WHERE
key_id = 'f9cae6a6b3facd5eb4bf695671112bf72914fbdc2f0c20ac0d031106f1264e33'
AND (
token = 'naGT6ZcRSylC7hXDt/jnNQbOe7sOfQ6ZgaCtIpMT4rY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)