UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LPmZ14yHVFkozCOF4HcIQE4eQqXBI9gxQHRF201yHOw=' 
WHERE 
  key_id = '6f666aa870e232f8845eedb60c49690d61bb6000af3c884c2669ff7479525cb3' 
  AND (
    token = 'LPmZ14yHVFkozCOF4HcIQE4eQqXBI9gxQHRF201yHOw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034