SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bd63b8c8df66d48399078c2fffd4d44afc3b98be25c4e66c06d6467abeba7fc2' 
  AND token = 'lKDkdrNWyEAJsia6HKbnjmMirus1CCFzxVZY4P3I5b0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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