UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6nEiQypOgPvm0/Gqk0c4y4ajTF4kiRoP5NkFwirqvyM=' 
WHERE 
  key_id = '00c9299d6055726e959a9693ff3a66fa8353865595adb8f32a25869be327354e' 
  AND (
    token = '6nEiQypOgPvm0/Gqk0c4y4ajTF4kiRoP5NkFwirqvyM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026