UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8TWqB3d+1pcCZDUB4oPWDW6wh92XngsY+IXj8IabRq8='
WHERE
key_id = 'a04793847c5f133b33f60cb371f986c850ee03ceaed2cc0aa73cfcda245b7297'
AND (
token = '8TWqB3d+1pcCZDUB4oPWDW6wh92XngsY+IXj8IabRq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)