UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'M9Z8yglja3bvJBvq6Dj4TJ6kbUzCc9tHbNR+Tfp4aoE=' 
WHERE 
  key_id = '9db5ffc4e6e9dea7fa49b18e2018780c1ed189523a15e9aef8469662dd722f62' 
  AND (
    token = 'M9Z8yglja3bvJBvq6Dj4TJ6kbUzCc9tHbNR+Tfp4aoE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025