SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4ddb1ee268be70c7f71f8c2a25e1d948d80efe1b562e08510db09e3a2bce66d3' 
  AND token = 'ZmiWUarKKusf9ndTWO9m3Mb/e04y0LbPbodfP0UMONI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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