SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8622cea8d057997e54e4ad63914b97e4f27e0d57021996cf23c107ddd4859d73' 
  AND token = 'sfdttk7fBu+Due3XS010Wqx9CnVs7Ckv2YWH6g4BZkc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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