SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd7f4b0af0be3bca96bc8b3f5b15da0c8dd4eb7ddf5e42040b6d8f8627740ae4e' 
  AND token = 'HGdkVet9M1I+g6JWPnbGy4pmvvaBfMO4sxSu4OCSQVY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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