UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXnnT0g3GRHyM7n4nTsgfnRXQqZ5m7GWGjwoP0PwOqU='
WHERE
key_id = '949a5454fa619aafaff2ff825b1d66b04dfc6eee657a4eb3bf85e365b3270cce'
AND (
token = 'pXnnT0g3GRHyM7n4nTsgfnRXQqZ5m7GWGjwoP0PwOqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)