SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '59b751e81fc1e1ea3639897069ee43e7cce551ef9ce2327e50312c794e20b948' 
  AND token = 't+hpfOLsAJlB9OMcbk84efSUeeX2koM/F1YF2+vKZ6M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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