UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSPDCA6DHWBHjarv/mZP1bCYQG9y8oY0Al1tUn8I2do='
WHERE
key_id = '5462a1e288ae045c5a24b36c7bda5097c607d8e34003e4e91471e0fede8433e7'
AND (
token = 'zSPDCA6DHWBHjarv/mZP1bCYQG9y8oY0Al1tUn8I2do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)