UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VeqdYLQE1R2sByemfDmQHidXi9vlQYJlCNwswwlyRB4='
WHERE
key_id = 'f6ea3c0e19b7eaae33ea6cea7cb192fcda681b7909e462e1ac15e41f9fd3f396'
AND (
token = 'VeqdYLQE1R2sByemfDmQHidXi9vlQYJlCNwswwlyRB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)