SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '47a028cfc233bc0b31b84a70c4ed701c27a5b3db359f5946b003fe2e9a688dfc' 
  AND token = 'tSGbSPwLukb8d6zIZV4Pq7NVZJHakWxjr8YQoiJECmQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

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