UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'F+yVb/Lyak1V/9qvJ4gVE4vBTdRh/KYSINF+Xpi5caE=' 
WHERE 
  key_id = '12a7d61ea202ac4af595d7c273d1e5326e71779c1bde3a8e58fc91d8605326c2' 
  AND (
    token = 'F+yVb/Lyak1V/9qvJ4gVE4vBTdRh/KYSINF+Xpi5caE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00075