SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c81192a03110b389bf85b96321e7296cf4ffd2d0328786e5bce2a9837e0f7851' 
  AND token = 'vonbV6GUE/7jLJS8PR9QT4jGtgeAXEREPaGDFcemYCc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00078

JSON explain

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