SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'dcab8db5c952a03d58c83cb5e94bcc2296d366cff16c99ad2b82f8733f151228' 
  AND token = 'h0N+5sguM/ai/FqzW8O9sE/2EefgbiY1EKap5fkyGuc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}