SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cdd0b3f1b195f8266b3e8c29cc0b54c2e46f1e0e6a3f44ec27c04820d8183415' 
  AND token = 'UQl6DXSi/9UXsqWTzD/sG0UKU1otrxFwil00elBn0Ac=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00037

JSON explain

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