UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZwROC7EWVLTqpIXN7+wBrT/EsWTFr2JcekV9t9L3nU='
WHERE
key_id = '02d3aa87c990a09625b30fe60b50378b14ce8628347c663cdac173d8d5176969'
AND (
token = 'hZwROC7EWVLTqpIXN7+wBrT/EsWTFr2JcekV9t9L3nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)