UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VXbCmqg81zpuqOVriLjertyy4TkugkiU6kA0st+kAR8='
WHERE
key_id = 'd4a94d3ab863ce49bb3fb7e5adddea4cb3dacdc51066b7ab021d1a48355977f4'
AND (
token = 'VXbCmqg81zpuqOVriLjertyy4TkugkiU6kA0st+kAR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)