UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZM2ZQzNWyOyQNGFlSso02+OMzThr+tsGn0zxWwHnrM='
WHERE
key_id = '686f5273f7df78fb7d1106e4f2a8ca97d456d255f4695467a009686e17154ae1'
AND (
token = 'lZM2ZQzNWyOyQNGFlSso02+OMzThr+tsGn0zxWwHnrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)