SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ddfa7864e5d222d9c9693808ea583c101d8944c573d62dfe5fcb3eef04c5b97c' 
  AND token = 'o0dcDUd7FpNef+MNjjvfKq0FtRc3HGA3jk7Mv0oSC/o=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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